DataEngine for .NET Standard | ComponentOne
C1.PivotEngine Assembly / C1.PivotEngine Namespace / C1PivotEngine Class / GetUniqueValues Method / GetUniqueValues(String,String,Dictionary<String,Object>,String,CancellationToken) Method
Path in the server's file system where DataEngine data is saved in files.
The name of a DataEngine table.
View definition used for performing aggregation.
The name of the field to provide unique values for.
Enables task cancellation.

In This Topic
    GetUniqueValues(String,String,Dictionary<String,Object>,String,CancellationToken) Method
    In This Topic
    Lists unique values of a field for the server's clients.
    Syntax
    'Declaration
     
    Public Overloads Shared Function GetUniqueValues( _
       ByVal workspace As String, _
       ByVal table As String, _
       ByVal view As Dictionary(Of String,Object), _
       ByVal fieldName As String, _
       ByVal cancelToken As CancellationToken _
    ) As Task(Of IList)
    public static Task<IList> GetUniqueValues( 
       string workspace,
       string table,
       Dictionary<string,object> view,
       string fieldName,
       CancellationToken cancelToken
    )

    Parameters

    workspace
    Path in the server's file system where DataEngine data is saved in files.
    table
    The name of a DataEngine table.
    view
    View definition used for performing aggregation.
    fieldName
    The name of the field to provide unique values for.
    cancelToken
    Enables task cancellation.

    Return Value

    Collection of objects with properties Name (string) and Type (System.Type)
    Remarks

    Using this method, a client can show a list of values for the user to choose from.

    Specifying the view (and not just a field name) for which values are to be listed is necessary because list of values can depend on the field's format (for example, values can be rounded).

    Clients need to be aware that getting value list can take considerable time if number of rows in the source data is very large.

    See Also